home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Precision Software Appli…tions Silver Collection 4
/
Precision Software Applications Silver Collection Volume 4 (1993).iso
/
database
/
rl10we.arj
/
RLISTX.HLP
< prev
next >
Wrap
Text File
|
1993-01-17
|
37KB
|
1,030 lines
--------------------------------------------
Copyright (c) 1993 R/ACCESS Software, Inc.
All rights reserved.
--------------------------------------------
%%
1,0:1
2,0:1
2,1:2
2,2:4
2,3:6
2,4:8
2,5:9
2,6:10
3,0:1
3,1:11
3,2:12
3,3:15
3,4:16
3,5:13
4,0:1
4,1:17
4,2:18
4,3:19
4,4:20
5,0:1
5,1:21
5,2:22
5,3:22
6,0:1
6,1:24
6,2:25
6,3:26
6,4:27
6,5:28
7,0:1
7,1:29
7,2:30
8,0:1
8,1:31
8,2:32
8,3:41
%%
.1
Help <F1> Type 1st letter of topic or to highlight and press <Enter>
┌ General ───────┐ ┌ View ──────────────────┐ ┌ Restore ──────────────────┐
│ @2[Edit rLIST ] │ │ @11[Previous record ] │ │ @17[current Field <Ctrl-F>] │
│ @4[Edit NotePad ] │ │ @12[Next record ] │ │ @18[All fields <Ctrl-A>] │
│ @6[Find record(s)] │ │ @15[Where clause <F11>] │ │ @19[NotePad text <Ctrl-N>] │
│ @8[Delete record ] │ │ @16[Sort clause <F12>] │ │ @20[Window positions <Ctrl-W>] │
│ @9[Add record ] │ │ @13[Record Queue <Alt-F10>] │ └───────────────────────────┘
│ @10[Phone call ] │ └────────────────────────┘
└────────────────┘
┌ Options ─────────────────────┐
┌ Mark ────────────────────────────────┐ │ @24[WP Secondary file <Ctrl-S>] │
│ @21[Mark/unmark current record <Ctrl-M>] │ │ @25[Directory scanner <Ctrl-D>] │
│ @22[mark Selected record(s) <Ctrl-F2>] │ │ @26[cOnfiguration file <Ctrl-O>] │
│ @22[Unmark selected record(s) <Shft-F2>] │ │ @27[keystroke Record <Ctrl-R>] │
└──────────────────────────────────────┘ │ @28[keystroke Playback <Ctrl-P>] │
└──────────────────────────────┘
┌ Programs ────────────┐ ┌ Help ──────┐
│ @29[R:BASE <Alt-1>] │ │ @31[Help <F1>] │ ╔═════════════════════════╗
│ @30[WordPerfect <Alt-2>] │ │ @32[About ] │ ║ @34[ Record Counter ] ║
└──────────────────────┘ │ @41[Shareware ] │ ║ @35[Special Keys and Fields] ║
└────────────┘ ║ @37[ Column Indexes ] ║
┌ Exit ─────┐ ╔═════════════════╗ ║ @40[ Database Pack ] ║
│ @33[Exit <F9>] │ ║ @0[Exit Help <Esc>] ║ ║ @38[ rLIST Table Schema ] ║
└───────────┘ ╚═════════════════╝ ╚═════════════════════════╝
.2
General -- Edit rLIST
The rLIST window allows adding and editing of data to all rLIST table columns
except rNotePad. Changes made to the current record are saved automatically
upon a successful Find, Next record, Previous record, or Exit.
The following keys provide field movement within the rLIST window:
<Tab> - Moves to the next field
<Shft-Tab> - Moves to the previous field
<Dn arrow> - Moves to the next field
<Up arrow> - Moves to the previous field
<Enter> - Moves to the next field
<Ctrl-Home> - Moves to the first field
<Ctrl-End> - Moves to the last field
The following keys provide field editing within the rLIST window:
<Lft arrow> - Moves one character position to the left
<Rt arrow> - Moves one character position to the right
<Home> - Moves to the beginning of the field
<End> - Moves to the end of the field
@3[Next screen] @-1[Previous screen] @0[Exit Help <Esc>]
.3
General -- Edit rLIST (continued)
<Insert> - Toggles between insert and overwrite mode
<Delete> - Deletes the character directly over the cursor
<Backspace> - Deletes the character to the left of the cursor and moves the
cursor one space to the left
<Ctrl-Del> - Deletes the entire contents of the current field and moves
the cursor to the beginning of the field
<Alt-Del> - Deletes the character directly over the cursor and all
characters to the end of the field
<Ctrl-F> - Restores the current field's data to the original data (when
record was first retrieved with Next or Previous record)
<Ctrl-A> - Restores all rLIST field data to the original data (when
record was first retrieved with Next or Previous record)
These function keys perform the same within both the rLIST and NotePad windows:
<F1>-Help - Accesses cross-referenced help system
<F9>-Exit - Exits the rLIST program
<F10>-Menu - Accesses pull-down Menu bar (top of screen)
<F11>-Where - Displays current Where clause in pop-up window
<F12>-Sort - Displays current Sort clause in pop-up window
@-1[Previous screen] @0[Exit Help <Esc>]
.4
General -- Edit NotePad
The NotePad window allows adding and editing of text to the rLIST table column
rNotePad. The NotePad is a word wrapping text editor capable of holding up to
3,300 characters. The following keys provide text editing within the NotePad:
<Insert> - Toggles between insert and overwrite mode
(overwrite is the default mode)
<Delete> - Deletes the character directly over the cursor
<Backspace> - Deletes the character to the left of the cursor and moves the
cursor one position to the left
<Home> - Moves to the beginning of the current line
<End> - Moves to the end of the current line
<Up> - Moves the cursor up one line
<Down> - Moves the cursor down one line
<PgUp> - Displays the previous screen load
<PgDn> - Displays the next screen load
<Ctrl-Home> - Moves the cursor to the top of the text
<Ctrl-End> - Moves the cursor to the bottom of the text
<Enter> - In insert mode, inserts CR-LF and moves the cursor to the
first position of the next line. In overwrite mode, moves
the cursor to the beginning of the next line
@5[Next screen] @-1[Previous screen] @0[Exit Help <Esc>]
.5
General -- Edit NotePad (continued)
<Tab> - Inserts a tab character at the current cursor location
<Ctrl-N> - Restores the NotePad text to the original state (when record
was first retrieved with Find, Next record or Previous record)
<F2>-Srch - Searches (forward) for a specific text string (case sensitive)
<Alt-F2> - Finds the next occurrence of the text string
<F3>-Repl - Searches for and replaces (forward) a specific text string
(case sensitive)
<F4>-Block - Press <F4> to begin blocking. Use arrow keys to block text and
press <F4> again to end blocking. <Alt-F4> removes blocking
<F5>-NotePad - Removes the NotePad from the display screen. Use <Shft-F5> to
return to rLIST window and leave the NotePad on screen
<F6>-Copy - Copies a block of text to the cursor location
<F7>-Move - Moves a block of text to the cursor location
<F8>-Delete - Deletes a block of text
<Alt-F7> - Moves the cursor back one word
<Alt-F8> - Moves the cursor forward one word
IMPORTANT NOTE: See the rLIST User's Manual under Edit NotePad for information
regarding R:BASE note column compatibility.
@-1[Previous screen] @0[Exit Help <Esc>]
.6
General -- Find record(s)
Presents a pop-up window containing rLIST field names used in defining
conditions for the retrieval of rLIST table records for viewing and editing.
Once a field has been selected, another window with applicable comparison
operators for the field is displayed. Comparison operators that have two
trailing periods (e.g., Equal to..) will present a dialog window for data to be
entered and used by the chosen comparison operator. Find is not case sensitive
on data supplied to comparison operators.
Wildcard characters can be used in data supplied to the 'Equal to' and 'Not
equal to' comparison operators. Wildcard characters are the asterisk (*) and
the question mark (?). These wildcards employ similar functionality as their
MS-DOS counterparts. The asterisk is used to designate that all remaining
characters in the field are valid. The question mark is used in place of a
single character to designate that any character found in its place is valid.
The search criteria can be expanded or narrowed using logical connectors. After
the first condition is defined, a pop-up window with the following selections
appears: AND, AND NOT, OR, OR NOT, (Done).
@7[Next screen] @-1[Previous screen] @0[Exit Help <Esc>]
.7
General -- Find record(s) (continued)
These logical connectors may be used up to three times to group four separate
conditions together. The final search criteria is evaluated from left to right.
If the last logical connector is AND and the last condition uses the "Equal to"
operator on an indexed (key) column, the index is used and will invoke a very
rapid search and retrieval of the rLIST table's records.
If Find is unsuccessful, the specified search criteria is displayed with the
message 'No record(s) found for this criteria' and the current Where clause
remains in effect.
Upon a successful Find, rLIST will:
» Save all changes made to the current record
» Retrieve and display the initial record found for the new @15[Where clause]
» Sort the found records according to the @16[Sort clause]
(Sort order is defined in @26[cOnfiguration file])
» Reset the @34[Record Counter]'s current record number to one (1) and total
record number to the total number of records found for the new Where
clause
» Reset the @13[Record Queue] to one (1)
@-1[Previous screen] @0[Exit Help <Esc>]
.8
General -- Delete record
Delete the currently displayed rLIST record (and associated NotePad) from the
rLIST table and remove its reference from the Record Queue.
CAUTION: Once a record is deleted, it cannot be restored.
@-1[Previous screen] @0[Exit Help <Esc>]
.9
General -- Add record
Use to add a new record to the rLIST table.
Data that is entered into newly added records does not have to satisfy the
conditions of the current Where clause and these records are not automatically
sorted according to the current Sort clause. Instead, each new record is placed
in front of the current record and its reference is added to the Record Queue.
Added records become available for viewing and editing provided they satisfy the
conditions of the new Where clause established by a successful Find. These
records will then be sorted in the order specified by the current Sort clause.
@-1[Previous screen] @0[Exit Help <Esc>]
.10
General -- Phone call
Position the cursor on a phone field and select Phone call under General of the
pull-down Menu <F10> or press <F6> if rLIST is the active window to dial the
phone number through a modem. The mouse can also be used to dial a phone number
by double-clicking the left mouse button on a phone field.
If the current field is not a phone field and there is only one phone number
that exists, Phone call will automatically dial that phone number or, if more
than one phone number exists, a pop-up window will prompt for which phone number
to dial.
Upon dialing, the available options are:
┌────────────────────────────────────────────────────────────────────────────┐
│ ON RING: Lift the receiver and then press <Spacebar> to establish voice │
│ communication. │
│ ON BUSY: Wait while the phone number is redialed up to the number of times │
│ specified in @26[cOnfiguration file] or press the <Spacebar> to abort │
│ during the busy signal. │
│TO ABORT: Press <Spacebar>. │
└────────────────────────────────────────────────────────────────────────────┘
@-1[Previous screen] @0[Exit Help <Esc>]
.11
View -- Previous record
Use to retrieve and display the previous record listed in the Record Queue.
Changes made to the current record are saved automatically when Previous record
is invoked.
@-1[Previous screen] @0[Exit Help <Esc>]
.12
View -- Next record
Use to retrieve and display the next record from the rLIST table based on the
Where clause or the next record listed in the Record Queue. Changes made to the
current record are saved automatically when Next record is invoked.
@-1[Previous screen] @0[Exit Help <Esc>]
.13
View -- Record Queue <Alt-F10>
rLIST has an internal memory buffer large enough to keep a list of references to
approximately three thousand records from the rLIST table at any one time. This
list of references is known as the Record Queue.
The Record Queue is reset to one (1) upon each successful Find. It is then
incremented by one (1) each time a record is retrieved from the rLIST table with
Next record or a new record is added to the rLIST table with Add record. Press
<Alt-F10> to invoke a pop-up window that displays the number of available
(unused) references in the Record Queue.
If the Record Queue should become full, a pop-up window will display the message
"Record Queue is full!." In this event, the following two rLIST functions will
NOT be available:
» Add record will NOT add a new record.
» Next record will only retrieve records that have been previously retrieved
from the rLIST table. No new records will be retrieved from the rLIST
table even though there may be records available that would normally be
retrieved based on the Where clause.
@14[Next screen] @-1[Previous screen] @0[Exit Help <Esc>]
.14
View -- Record Queue <Alt-F10> (continued)
Invoking a successful Find will free the Record Queue and allow these two
functions to work normally. This may also necessitate the need to plan a
strategy for narrowing the search criteria when issuing Find so that fewer
number of records are retrieved for editing.
@-1[Previous screen] @0[Exit Help <Esc>]
.15
View -- Where clause <F11>
Displays the current search criteria in a pop-up window. Records are retrieved
from the rLIST table by Next record according to the search criteria that is
defined via Find. Two-letter abbreviations for several comparison operators are
used in the Where clause:
EQ - Equal to.. Count GT 0 - Access to all records.
NE - Not equal to.. This is the default on
GT - Greater than.. program startup.
GE - Greater than or equal to..
LT - Less than..
LE - Less than or equal to..
The following two rLIST fields display different formats in the Where clause
when used with a comparison operator that requires data:
Field Value
───────────────────────────────────
Timefld - twenty-four hour time
Timer - number of elapsed seconds
@-1[Previous screen] @0[Exit Help <Esc>]
.16
View -- Sort clause <F12>
Displays the current Sort clause in a pop-up window. Press <Enter> or
mouse-click to remove the pop-up window from the display screen. Records that
are retrieved from the rLIST table are sorted according to the Sort clause that
is defined via cOnfiguration file.
Note: Added records are not automatically sorted according to the current Sort
clause. Instead, each new record is placed in front of the current record and
its reference is added to the Record Queue. Upon each successful Find, Added
records become available for viewing and editing provided they satisfy the
conditions of the new @15[Where clause] established by Find. These records will
then be sorted in the order specified by the Sort clause.
@-1[Previous screen] @0[Exit Help <Esc>]
.17
Restore -- current Field <Ctrl-F>
Restores the current (cursor position) field data that was originally displayed
when the record was first retrieved with Find, Previous record or Next record.
Changes made to the current record are saved automatically when a successful
Find, Previous record, Next record or Exit is invoked. This feature is only
available when rLIST is the active window.
@-1[Previous screen] @0[Exit Help <Esc>]
.18
Restore -- All fields <Ctrl-A>
Restores all fields in the rLIST window (not the NotePad) that was originally
displayed when the record was first retrieved with Find, Previous record or Next
record. Changes made to the current record are saved automatically when a
successful Find, Previous record, Next record or Exit is invoked. This feature
is only available when rLIST is the active window.
@-1[Previous screen] @0[Exit Help <Esc>]
.19
Restore -- NotePad text <Ctrl-N>
Restores all text in the NotePad that was originally displayed when the record
was first retrieved with Find, Previous record or Next record. Changes made to
the NotePad text are saved automatically when a successful Find, Previous
record, Next record or Exit is invoked. This feature is only available when
NotePad is the active window.
@-1[Previous screen] @0[Exit Help <Esc>]
.20
Restore -- Window positions <Ctrl-W>
Restores both the rLIST and NotePad windows to rLIST default size and position
coordinates.
The rLIST or NotePad window can be repositioned on the display screen by holding
down the <Ctrl> key and pressing an arrow key to move the window (in the
direction of the arrow key) to a new location. The mouse can also be used to
reposition either window. Place the mouse cursor on the selected window border,
hold down the left mouse button and reposition the window by moving the mouse.
The rLIST window can be resized by holding down the <Alt> key and pressing the
<Up> or <Down> arrow keys. If made smaller, fields within the rLIST window will
scroll using the <Enter>, <Tab>, <Shft-Tab>, <PgUp> or <PgDn> keys. The NotePad
window can be made larger or smaller by holding down the <Alt> key and pressing
an arrow key to resize the window. The mouse can also be used to resize either
window. Place the mouse cursor on the selected window border's corner, hold
down the left mouse button and resize the window by moving the mouse.
Window size and position coordinates are automatically stored in cOnfiguration
file for subsequent sessions.
@-1[Previous screen] @0[Exit Help <Esc>]
.21
Mark -- Mark/unmark current record <Ctrl-M>
Toggles the current record's Marking status on and off. When a record is
Marked, the rLIST window border is highlighted.
The @24[WP Secondary file] feature creates a WordPerfect secondary file from all
Marked records in the rLIST table.
@-1[Previous screen] @0[Exit Help <Esc>]
.22
Mark -- Mark/Unmark Selected record(s) <Ctrl-F2>, <Shft-F2>
Use to Mark or Unmark selected records from the rLIST table. When a record is
Marked, the rLIST window border is highlighted.
The @24[WP Secondary file] feature creates a WordPerfect secondary file from all
Marked records in the rLIST table.
A pop-up window appears containing rLIST field names used in defining conditions
for Marking or Unmarking rLIST table records. Once a field has been selected,
another window with applicable comparison operators for the field is displayed.
Comparison operators that have two trailing periods (e.g., Equal to..) will
present a dialog window for data to be entered and used by the chosen comparison
operator. Mark and Unmark Selected Record(s) are not case sensitive on data
supplied to comparison operators.
Wildcard characters can be used in data supplied to the 'Equal to' and 'Not
equal to' comparison operators. Wildcard characters are the asterisk (*) and
the question mark (?). These wildcards employ similar functionality as their
MS-DOS counterparts. The asterisk is used to designate that all remaining
characters in the field are valid. The question mark is used in place of a
single character to designate that any character found in its place is valid.
@23[Next screen] @-1[Previous screen] @0[Exit Help <Esc>]
.23
Mark -- Mark/Unmark Selected record(s) <Ctrl-F2>, <Shft-F2> (continued)
The Marking or Unmarking criteria can be expanded or narrowed using logical
connectors. After the first condition is defined, a pop-up window with the
following selections appears: AND, AND NOT, OR, OR NOT, (Done).
These logical connectors may be used up to three times to group four separate
conditions together. The final search criteria is evaluated from left to right.
If the last logical connector is AND and the last condition uses the "Equal to"
operator on an indexed (key) column, the index is used and will invoke a very
rapid Marking or Unmarking of the rLIST table's records.
After Marking or Unmarking is complete, a pop-up window will display the number
of records Marked or Unmarked. Press <Enter> or mouse-click to remove the
pop-up window.
@-1[Previous screen] @0[Exit Help <Esc>]
.24
Options -- WP Secondary file <Ctrl-S>
Creates a WordPerfect secondary file from all Marked records in the rLIST table.
First, a dialog window is displayed for entering the drive, path and file name
of the file being created. The default is the full path name of the currently
active R:BASE database with the file name extension "SEC." Either all rLIST
table columns or specified columns only may be selected for the WordPerfect
secondary file output. A sort order can then be designated for the selected
columns, if desired. Finally, a pop-up window prompts a request for the
WordPerfect version number (5.0 or 5.1). The WordPerfect secondary file is then
created.
@-1[Previous screen] @0[Exit Help <Esc>]
.25
Options -- Directory scanner <Ctrl-D>
Use to locate all R:BASE databases beginning with a specified path designation
and throughout all "child" subdirectories. R:BASE databases that contain an
rLIST table are indicated with an asterisk (*). The currently active database
is indicated with a check mark (√). Use <PgUp>, <PgDn> or the mouse to display
the entire listing. Use to select a new R:BASE database and press <Enter> to
make it the current database. This allows the rLIST table in the newly selected
R:BASE database to become the current rLIST table.
Upon selecting a new R:BASE database, settings in the new database cOnfiguration
file take effect immediately and the current Where clause is reset to Find all
records (Count GT 0).
@-1[Previous screen] @0[Exit Help <Esc>]
.26
Options -- cOnfiguration file <Ctrl-O>
The cOnfiguration file holds default values of specific options available for
each R:BASE database. Every R:BASE database that is accessed at least once by
the rLIST program will have its own cOnfiguration file. This allows the user to
customize default parameters for each R:BASE database used by rLIST.
Default parameters available within cOnfiguration file are:
» Window position coordinates for the rLIST and NotePad windows
» ON/OFF - Field validation for U.S. postal code state abbreviations
» Touch tone or pulse and serial port number for Phone call
» Number of times to redial on busy signal and seconds to pause
before redial
» User defined alias' for rLIST column names:
rTxtfld1, rTxtfld2, rTxtfld3, rDatefld, rTimefld
» Sort specification for up to 10 fields
» Prefix/suffix dial codes for Phone call
[ ] <-- in phone fields: letter of code, 1, or blank
The file name given to each cOnfiguration file is dbname.RLC with dbname being
the name of its associated R:BASE database.
@-1[Previous screen] @0[Exit Help <Esc>]
.27
Options -- keystroke Record <Ctrl-R>
Creates a playback (macro) file for use with keystroke Playback. Playback files
are used to automate repetitive tasks such as typing the same text repeatedly or
invoking a series of function key commands that are used frequently. A playback
file consists of a series of keystrokes, mouse events and special commands that
are recorded in the exact sequence in which they are performed and can then be
automatically executed by @28[keystroke Playback].
First, a dialog window is displayed for entering the drive, path and file name
of the playback file being created. If the drive and path are omitted, the
playback file will be created in the default directory. The use of a common
file name extension, e.g., MAC, PLY or KEY, is recommended since this practice
can provide for easier file maintenance under DOS. Upon pressing <Enter>,
keystroke Record is engaged and all keystrokes and mouse events are then
recorded in the playback file until <Ctrl-R> is pressed.
Keystroke Record writes keystrokes to the designated file as ASCII characters.
This file may be edited with an ASCII text editor to include the following
special command:
{PROMPT} - suspends keystroke Playback until a key is pressed.
@-1[Previous screen] @0[Exit Help <Esc>]
.28
Options -- keystroke Playback <Ctrl-P>
Invoke a playback (macro) file that has been created by keystroke Record.
Playback files are used to automate repetitive tasks such as typing the same
text repeatedly or invoking a series of function key commands that are used
frequently. A playback file consists of a series of keystrokes, mouse events
and special commands that are recorded in the exact sequence in which they are
performed during @27[keystroke Record] and can then be automatically executed by
keystroke Playback.
@-1[Previous screen] @0[Exit Help <Esc>]
.29
Programs -- R:BASE <Alt-1>
Use to invoke R:BASE or Personal R:BASE from within rLIST. R:BASE or Personal
R:BASE will be invoked providing that the program files for one or the other
resides in the current directory or is contained in a directory that is listed
in the PATH environment variable. The entire resource of the respective program
is available with this option. Ad hoc reports and queries on data residing in
rLIST tables can be done using R:BASE or Personal R:BASE, as well as the
creation of new R:BASE databases for the inclusion of new rLIST tables.
The environment variable RLISTRB may be used to define a path specification for
the execution of R:BASE or Personal R:BASE. Use the full path name in naming
(e.g., SET RLISTRB=C:\RBPERSL\RBASE.EXE). Note that there are no spaces between
the '=' mark. When defined, this environment variable will take precedence over
the default directory or the path environment variable.
@-1[Previous screen] @0[Exit Help <Esc>]
.30
Programs -- WordPerfect <Alt-2>
Use to invoke WordPerfect from within rLIST. WordPerfect will be invoked
providing that the WordPerfect program files are in the current directory or
contained in a directory that is listed in the PATH environment variable. The
entire resource of WordPerfect is available with this option. As rLIST
generates WordPerfect secondary files automatically, these secondary files can
be merged together with primary files for the creation of mail merge letters,
envelopes, labels, etc.
The environment variable RLISTWP may be used to define a path specification for
the execution of WordPerfect. Use the full path name in naming (e.g., SET
RLISTWP=C:\WP51\WP.EXE). Note that there are no spaces between the '=' mark.
When defined, this environment variable will take precedence over the default
directory or path environment variable.
@-1[Previous screen] @0[Exit Help <Esc>]
.31
Help -- Help <F1>
Select Help from the pull-down Menu <F10> or press <F1> to bring up the
cross-referenced Help system. The Help system is context sensitive in the
pull-down Menu. Highlight a pull-down Menu selection and press <F1> to access
Help screen(s) for a particular task.
@-1[Previous screen] @0[Exit Help <Esc>]
.32
Help -- About
Select About under Help of the pull-down Menu <F10> to display the current
rLIST version number, copyright notice and information for contacting
R/ACCESS Software, Inc.
@-1[Previous screen] @0[Exit Help <Esc>]
.33
Exit -- Exit <F9>
Select Exit of the pull-down Menu or press <F9> to exit the rLIST program.
Changes made to the current record are saved automatically when Exit is invoked.
@-1[Previous screen] @0[Exit Help <Esc>]
.34
Record Counter -> #### of ####
The Record Counter exists in the top right-hand corner of the rLIST window,
directly above the First name field. Its function is to display the current
record number and the total number of records found for the Where clause plus
the number of Added records. Added records are those records that have been
added since the most recent Find. The following is an example:
345 of 1025
which could be interpreted as:
345 is the current record number of 1000 total records
found for the Where clause plus 25 Added records
@-1[Previous screen] @0[Exit Help <Esc>]
.35
Special Keys and Fields
<Spacebar> or double mouse-click on:
Field Action
──────────────────────────────────────────────────
Datefld - Inserts today's (system) date and day
Timefld - Inserts today's (system) time
Timer - Toggles Timer on and off
State/ - Presents a pop-up window for the selection of U.S.
Province postal code state abbreviations
In cOnfiguration file <Ctrl-O>, rLIST and NotePad window screen default
coordinates change to reflect the current window display screen
coordinates.
<F6> or double mouse-click on:
Field Action
──────────────────────────────────────────────────
Phone fields - Dials the phone number through a modem
@36[Next screen] @-1[Previous screen] @0[Exit Help <Esc>]
.36
Special Keys and Fields (continued)
Grey plus/minus keys on:
Field Action
──────────────────────────────────────────────────
Datefld - Increases/decreases date by one day
Timefld - Increases/decreases time by one minute
In cOnfiguration file <Ctrl-O>, rLIST and NotePad window screen default
coordinates increase/decrease to within valid limits
<Alt-Lft arrow> / <Alt-Rt arrow> on:
Field Action
──────────────────────────────────────────────────
Phone fields - Moves the cursor position to prefix, area code,
phone number, suffix
Datefld - Moves cursor position to month, day, year
Timefld - Moves cursor position to hour, minute, am/pm
Timer - Moves cursor position to hour, minute, seconds
@-1[Previous screen] @0[Exit Help <Esc>]
.37
Column Indexes
There is no facility within rLIST for creating or deleting indexes (keys) on
rLIST table columns. The creation or deletion of indexes can be accomplished
with R:BASE or Personal R:BASE. INDEXR.EXE, which is shipped with Microrim's
R:SCOPE database diagnostic program, also creates indexes on specified columns.
@-1[Previous screen] @0[Exit Help <Esc>]
.38
rLIST Table Schema
R:BASE Col rLIST Field Type Description
───────────────────────────────────────────────────────────────────
1 rHonor Honorific TEXT 16 Mr./Ms./Mrs. etc.
2 rLName Last name TEXT 16 Person's last name
3 rFName First name TEXT 18 Person's first name
4 rTitle Title TEXT 36 Title/job description
5 rCompany Company TEXT 36 Company
6 rAddrs1 Address1 TEXT 36 Address line 1
7 rAddrs2 Address2 TEXT 36 Address line 2
8 rAddrs3 Address3 TEXT 36 Address line 3
9 rAddrs4 Address4 TEXT 36 Address line 4
10 rCity City TEXT 20 City
11 rState State/Province TEXT 4 State/Province abbrev.
12 rZipCode Zip/Postal code TEXT 10 Zip or Postal code
13 rCountry Country TEXT 20 Country
14 rBPrefix (none) TEXT 4 A-J, 1 or blank
15 rBArea Business areacode TEXT 4 Business area code
16 rBPhone Business phone TEXT 8 Business phone
17 rBSuffix (none) TEXT 4 A-J or blank
18 rBExt Bus. extension TEXT 4 Business extension
@39[Next screen] @-1[Previous screen] @0[Exit Help <Esc>]
.39
rLIST Table Schema (continued)
19 rMPrefix (none) TEXT 4 A-J, 1 or blank
20 rMArea Mobile areacode TEXT 4 Mobile area code
21 rMPhone Mobile phone TEXT 8 Mobile phone
22 rMSuffix (none) TEXT 4 A-J or blank
23 rFPrefix (none) TEXT 4 A-J, 1 or blank
24 rFArea Fax areacode TEXT 4 Fax area code
25 rFPhone Fax phone TEXT 8 Fax phone
26 rFSuffix (none) TEXT 4 A-J or blank
27 rHPrefix (none) TEXT 4 A-J, 1 or blank
28 rHArea Home areacode TEXT 4 Home area code
29 rHPhone Home phone TEXT 8 Home phone
30 rHSuffix (none) TEXT 4 A-J or blank
31 rTxtfld1 (user defined) TEXT 36 Text field 1
32 rTxtfld2 (user defined) TEXT 36 Text field 2
33 rTxtfld3 (user defined) TEXT 36 Text field 3
34 rDatefld (user defined) DATE Date field
35 rTimefld (user defined) TIME Time field
36 rTimer Timer INTEGER Total in seconds
37 rMarker Marker INTEGER R:BASE null or 1
38 rNotePad NotePad NOTE Note field
@-1[Previous screen] @0[Exit Help <Esc>]
.40
Database Pack
When an rLIST table record is deleted, the disk space formerly occupied by the
deleted record is not reused by rLIST. As more records are deleted, this unused
space accumulates. To recapture this disk space, it is necessary to PACK the
R:BASE database from time to time. This can be done using R:BASE or Personal
R:BASE with the PACK or RELOAD commands or with SEPACK, a utility provided with
the registered version of rLIST, at the DOS prompt. Be sure to have a backup
copy of the database before starting the procedure. PACK must NOT be
interrupted while in operation.
To PACK an R:BASE database using SEPACK, issue the following command at the DOS
prompt:
SEPACK {drive:\path\}dbname {Owner}
where dbname is the name of the R:BASE database
you wish to PACK
NOTE: PUBLIC is the default Owner password for R:BASE databases created by
R:BASE versions 3.x and greater. PUBLIC is the Owner password for the CONTACT
database supplied with rLIST.
@-1[Previous screen] @0[Exit Help <Esc>]
.41
Help -- Shareware Registration
Select Shareware Registration under Help of the pull-down Menu <F10> to display
information regarding the shareware registration of rLIST.
@-1[Previous screen] @0[Exit Help <Esc>]
.End